Re: [Pgreplication-general] DBMIRROR and INSERT transactions lose

Поиск
Список
Период
Сортировка
От Michael Loftis
Тема Re: [Pgreplication-general] DBMIRROR and INSERT transactions lose
Дата
Msg-id 94076935.1049077323@[10.1.2.77]
обсуждение исходный текст
Ответ на DBMIRROR and INSERT transactions lose time ...  (Hervé Piedvache <herve@elma.fr>)
Список pgsql-general
Couple of things here.  If I read you correctly after you COMMIT the first
part of the transaction goes quickly, but begins to slow down?

HAve you considered removing any indexes you have on the tables prior to
doing such a large insert and creating htem afterwards?  It's much cheaper
like that.

Does this happen if you don't run DBMirror (IE local only) copy?  I've
never used such large transactions myself before.

--On Monday, March 31, 2003 9:46 AM +0100 Hervé Piedvache <herve@elma.fr>
wrote:

> Hi,
>
> Who can give us some help with DBMirror ??
>
> We make some test with DBMirror ... for us it's running perfectly ;o)
>
> Only one big trouble ... inserting data in transaction ...
> We try to make one transaction with 320 000 inserts ... if the trigger of
> DBMirror is not connected we have 100 inserts done in 0.3 sec, with
> DBMirror  it start quickly but after 1000 insert we lose and lose many
> time ... 1  second losed by 3000/4000 insert ... after 9 hours we get 45
> sec for 100  insert ... :o(
>
> Any idea ? Update ? Patch ? ...
>
> Thanks per advance for your help ... ! :o)
>
> Regards,
> --
> Hervé
> _______________________________________________
> Pgreplication-general mailing list
> Pgreplication-general@gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pgreplication-general


В списке pgsql-general по дате отправления:

Предыдущее
От: "shreedhar"
Дата:
Сообщение: Fw: Query
Следующее
От: Pedro Alves
Дата:
Сообщение: Indexing timestamp columns